Columns
Indexes
Grants
Dependencies
Details
Columns
Indexes
Grants
Dependencies
Details
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
OBJ | VARCHAR2(20 BYTE) | Yes | null | 1 | null |
FILE_TAGLINE | VARCHAR2(400 BYTE) | Yes | null | 2 | null |
FILE_ID | VARCHAR2(100 BYTE) | Yes | null | 3 | null |
FILE_TYPE | VARCHAR2(100 BYTE) | Yes | null | 4 | null |
ALLEGATION | VARCHAR2(4000 BYTE) | Yes | null | 5 | null |
PARTIC_NAME | VARCHAR2(4000 BYTE) | Yes | null | 6 | null |
CREATED_ON | DATE | Yes | null | 7 | null |
CREATED_ON_FY | NUMBER | Yes | null | 8 | null |
INDEX_OWNER | INDEX_NAME | COLUMNS | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | COLUMN_EXPRESSION | JOIN_INDEX |
---|
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OBJECT_ID | OWNER | OBJECT_TYPE | OBJECT_NAME | STATUS | TYPE_LINK |
---|
References
NAME | VALUE |
---|---|
CREATED | 10-APR-24 |
LAST_DDL_TIME | 07-FEB-25 |
OWNER | QART |
MVIEW_NAME | MV_ALL_ALLEGATIONS |
CONTAINER_NAME | MV_ALL_ALLEGATIONS |
QUERY | SELECT O.SID OBJ, O.TAGLINE FILE_TAGLINE, O.ID FILE_ID, OT.DISPLAY FILE_TYPE, tic.DISPLAY ALLEGATION, SUB.SUBJECTS PARTIC_NAME, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY FROM MV_F_INFORMATION tfi INNER JOIN MV_INCIDENT_CATEGORIES tic ON tfi.INCIDENT = tic.SID INNER JOIN MV_ACM_OBJ O ON tfi.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON OT.SID = O.OBJ_TYPE LEFT OUTER JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_DISPLAY) OVER (PARTITION BY OBJ) AS SUBJECTS FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT') SUB ON tfi.OBJ = SUB.OBJ WHERE OT.OBJ_TYPE_CODE IN ('FILE.INFO_INV', 'FILE.COLL_INV') UNION SELECT O.SID OBJ, O.TAGLINE FILE_TAGLINE, O.ID FILE_ID, OT.DISPLAY FILE_TYPE, tar.DISPLAY ALLEGATION, sub.SUBJECTS PARTIC_NAME, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY FROM MV_F_INTAKE tfi INNER JOIN MV_ACM_OBJ O ON tfi.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON OT.SID = O.OBJ_TYPE INNER JOIN MV_ACM_REFERENCE tar ON tfi.INITIAL_ALLEGATION = tar.REF_KEY LEFT OUTER JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_DISPLAY) OVER (PARTITION BY OBJ) AS SUBJECTS FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT') SUB ON tfi.OBJ = SUB.OBJ WHERE OT.OBJ_TYPE_CODE = 'FILE.INTAKE' UNION SELECT O.SID OBJ, O.TAGLINE FILE_TAGLINE, O.ID FILE_ID, OT.DISPLAY FILE_TYPE, tar.DISPLAY ALLEGATION, sub.SUBJECTS PARTIC_NAME, O.CREATED_ON CREATED_ON, O.CREATED_ON_FY CREATED_ON_FY FROM MV_F_THREAT_INVEST tfti INNER JOIN MV_ACM_OBJ O ON tfti.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON OT.SID = O.OBJ_TYPE INNER JOIN MV_ACM_REFERENCE tar ON tfti.THREAT_CATEGORY = tar.REF_KEY LEFT OUTER JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_DISPLAY) OVER (PARTITION BY OBJ) AS SUBJECTS FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT') SUB ON tfti.OBJ = SUB.OBJ WHERE OT.OBJ_TYPE_CODE = 'FILE.THREAT_INV' |
QUERY_LEN | 2676 |
UPDATABLE | N |
UPDATE_LOG | null |
MASTER_ROLLBACK_SEG | null |
MASTER_LINK | null |
REWRITE_ENABLED | N |
REWRITE_CAPABILITY | TEXTMATCH |
REFRESH_MODE | DEMAND |
REFRESH_METHOD | COMPLETE |
BUILD_MODE | IMMEDIATE |
FAST_REFRESHABLE | NO |
LAST_REFRESH_TYPE | COMPLETE |
LAST_REFRESH_DATE | 07-FEB-25 |
LAST_REFRESH_END_TIME | 07-FEB-25 |
STALENESS | NEEDS_COMPILE |
AFTER_FAST_REFRESH | NEEDS_COMPILE |
UNKNOWN_PREBUILT | N |
UNKNOWN_PLSQL_FUNC | N |
UNKNOWN_EXTERNAL_TABLE | N |
UNKNOWN_CONSIDER_FRESH | N |
UNKNOWN_IMPORT | N |
UNKNOWN_TRUSTED_FD | N |
COMPILE_STATE | NEEDS_COMPILE |
USE_NO_INDEX | Y |
STALE_SINCE | null |
NUM_PCT_TABLES | 0 |
NUM_FRESH_PCT_REGIONS | null |
NUM_STALE_PCT_REGIONS | null |
SEGMENT_CREATED | YES |
EVALUATION_EDITION | null |
UNUSABLE_BEFORE | null |
UNUSABLE_BEGINNING | null |
DEFAULT_COLLATION | USING_NLS_COMP |
ON_QUERY_COMPUTATION | N |
DUPLICATED | N |
SHARDED | N |